USE Communicator;
GO

CREATE TRIGGER CreateEntriesForNewUser ON dbo.aspnet_Users
AFTER INSERT 
AS
DECLARE @insertedUser uniqueidentifier;
SET @insertedUser = (SELECT UserId FROM inserted)
INSERT INTO User_Settings VALUES (@insertedUser, 1, NULL, NULL, 1, 1, NULL)
INSERT INTO User_Personal_Data VALUES (@insertedUser, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT INTO ContactLists VALUES (@insertedUser)
GO
